| Author |
Thread Statistics | Show CCP posts - 7 post(s) |
|
CCP Prism X
C C P
C C P Alliance
214
   |
Posted - 2011.12.01 08:50:00 -
[1] - Quote
There were some errors in the original dump that were discovered when the same static data hit TQ. That and general post expansion busyness is causing this delay.
Terribly sorry, will get the ball rolling on this ASAP.
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
|
CCP Prism X
C C P
C C P Alliance
220
|
Posted - 2011.12.02 08:46:00 -
[2] - Quote
It currently has errors.
SELECT *
FROM dbo.agtAgents
WHERE locationID < 60000000
Will show you that all agents in space have locationIDs of stations (Because we all know that the only valid locations for agents are stations and solar systems so that anything below 60Mils must be located in systems!). It's because of a change in our internal processes with how we treat NPC Characters VS Player Characters and how that static data is copied around our servers. It has been fixed internally and I'm tryingto push for its (SDEs) regeneration and deployment but people are just very busy these post-expansion-deployment-days.
P.S. I am very disappointed in these forums forcing me to break our SQL coding standards! 
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
|
CCP Prism X
C C P
C C P Alliance
225
|
Posted - 2011.12.05 08:02:00 -
[3] - Quote
Zifrian wrote:The invItems table seems to be incomplete (I hope). There are no asteroids in the table anymore.
This is from Incarna:
Select top 10 invTypes.typeName, invGroups.groupName
from invTypes, invItems, invGroups
where invTypes.typeID = invItems.typeID
and invTypes.groupID = invGroups.groupID
and invGroups.categoryID = 25
group by invGroups.groupName, invTypes.typeName
No, we sanitized a lot of stuff out of invItems, asteroids included.
Desmont McCallock wrote:Would be nice if it included the SQL script file.
Not very hot on releasing anything about our own internal structure of things. Not that obscurity is security but transparency isn't either. 
Desmont McCallock wrote:
Changes (possible breaking) found:
- agtConfig -> empty table ??? (edit: related data have been inserted in agtAgents table, which was about time)
- dgmAttributeTypes -> some attributeName values are NULL (intended?)
- eveNames -> renamed to invNames
- eveLocations -> removed
- eveOwners -> removed
- invPositions -> added
- invUniqueNames -> added
- translationLaguages -> added (typo error on table name - contains no data, should be removed)
- translationTables -> added
- trnTranslationLanguages -> added
- warCombatZoneSystems -> added
- warCombatZones -> added
I thought the changelog had mentioned that eveNames and eveOwners were now invNames and invUniqueNames as well as that eveLocations is now invPositions.
The dogma attributes missing names is probably due to our new translation system, will look at that.
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
|
CCP Prism X
C C P
C C P Alliance
226
|
Posted - 2011.12.06 15:18:00 -
[4] - Quote
Stillman just posted the fixed version up in a sticky.
Sorry about the delay, I blame the plague.
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
|
CCP Prism X
C C P
C C P Alliance
226
|
Posted - 2011.12.06 15:52:00 -
[5] - Quote
The itemID is 64bit because the API can return 64bit itemIDs and the prudent developer might want to commit data he does not expect to change much to his local DB for a spell.
~ CCP Prism X
EVE Database Developer
"Prism X is my first world problem." ~ CCP FLX
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
|
CCP Prism X
C C P
C C P Alliance
480
|
Posted - 2012.01.05 13:17:00 -
[6] - Quote
"Only the highly advanced Ukomi superconductor can be rendered small enough for use in nano-factories, microscopic devices programmed to absorb and recycle ambient material into useful matter. Each factory is built from reactive metals, ensuring that they interact properly GÇô or not at all GÇô with their environment, while a mote of industrial explosive automatically destroys them when they have completed their task."
From the DB we generate the backup from.
~ CCP Prism X
EVE Database Developer
If anything in this post was informative or could be considered as 'good news' to you - chances are you've misread it. |
|
| |
|